﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DTO;
using System.Data;
namespace DataAccess
{
    public class TruyXuatThongTinKhachHang
    {
        KhachHang _khachhang = new KhachHang();

        public KhachHang khachhang
        {
            get { return _khachhang; }
            set { _khachhang = value; }
        }

        public DataTable TableKhachHang()
        {
            DataProvider dp = new DataProvider();
            dp.KetNoi();
            string sql = "Select * from KhachHang where TenTaiKhoan= '"+khachhang.TenTaiKhoan +"'";
            return dp.ExcuteQuery(sql);           
        }
        public DataTable ThongTinHoiVien()
        {
            DataProvider dp = new DataProvider();
            dp.KetNoi();
            string sql = "Select * from KhachHang where SoTheHoiVien= '" + khachhang.SoTheHoiVien + "'";
            return dp.ExcuteQuery(sql);
        }
    }
}
